-- @owner: zou_jialiang050
-- @date: 2024-15-06
-- @testpoint: 边界值测试

--step1:建表;expect:成功
drop sequence if exists seq_ustore_regr_sxx_008 cascade;
create sequence seq_ustore_regr_sxx_008 increment by 1 start with 10;
drop table if exists t_ustore_regr_sxx_008 cascade;
create table  t_ustore_regr_sxx_008(
     col_1 integer,
     col_2 number(19,0),
     col_3 number(10,6)
) with (storage_type=ustore);

begin
	for i in 1..50 loop
      insert into t_ustore_regr_sxx_008 values(
	  i,
      seq_ustore_regr_sxx_008.nextval,
	  i+445.255
	  );
    end loop;
end;
/

--step2:边界值测试;expect:成功
select regr_sxx(col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*15,col_3) from t_ustore_regr_sxx_008 order by 1;
select regr_sxx(col_3,col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*15) from t_ustore_regr_sxx_008 order by 1;
select regr_sxx(col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*15,col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*15) from t_ustore_regr_sxx_008 order by 1;
select regr_sxx(col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*31,col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*31) from t_ustore_regr_sxx_008 order by 1;
select regr_sxx(col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*32,col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*31) from t_ustore_regr_sxx_008 order by 1;
select regr_sxx(col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*31,col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*32) from t_ustore_regr_sxx_008 order by 1;
select regr_sxx(col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*32,col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*col_3*32) from t_ustore_regr_sxx_008 order by 1;

--step3:清理环境;expect:成功
drop sequence if exists seq_ustore_regr_sxx_008 cascade;
drop table if exists t_ustore_regr_sxx_008 cascade;